UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'capwXdq5LcVqzZUAJNujqL3vYEHinNE83zHnAd/PqwI='
WHERE
key_id = '42c22a3f4df95041437cda87c3e2b14e734d046b6aadd0260f59a2b4eb6b1ed0'
AND (
token = 'capwXdq5LcVqzZUAJNujqL3vYEHinNE83zHnAd/PqwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)