UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j4X8lryr0BvnkxZNDHym8rXeBsCH3FLuVjSBla6kKw0='
WHERE
key_id = '2216fdeba876ab18164639603a4d49263fa93bba8b8efdb3d251b4c77f83c12d'
AND (
token = 'j4X8lryr0BvnkxZNDHym8rXeBsCH3FLuVjSBla6kKw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)