UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S4qzhD5DNAC1UQhErsZmR1iltaaLSiWgNgoFHO/eKAw='
WHERE
key_id = 'cd63a365299eb2c4a495bf93282a3209ca44eb285c5a8799782c4e7c11a5d46d'
AND (
token = 'S4qzhD5DNAC1UQhErsZmR1iltaaLSiWgNgoFHO/eKAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)