UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MC07MY3u+WznbA7iaXtYohjs4zIVVFZvhRkj/LU4ASc='
WHERE
key_id = '7c4a5746fddcaedd92366426beb34d68abb99e2e9eeb286bff204b03653da664'
AND (
token = 'MC07MY3u+WznbA7iaXtYohjs4zIVVFZvhRkj/LU4ASc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)