UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Va40jZcuZKgCZxkk4aoftD2QOwfK/iAadKM6FUBecxU='
WHERE
key_id = '8dfca80a0b72f1c07e9dfdfc551e8b8ca44f9c3468c2010e336190c0195e47bf'
AND (
token = 'Va40jZcuZKgCZxkk4aoftD2QOwfK/iAadKM6FUBecxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)