UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nmXBoB00Y+bGfY2tcKJsk2086PPfENiuYeKMEZ5PzGk='
WHERE
key_id = 'efa7c0ae9d1d05d9a552b83c84800b0a5c0bed6d27bdadaf19e20f8a94951b8e'
AND (
token = 'nmXBoB00Y+bGfY2tcKJsk2086PPfENiuYeKMEZ5PzGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)