UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hs08lmUdhEAof9Eohb5S4wZNAR6BVToiTg2a6aH2oCA='
WHERE
key_id = 'b0be220f1df05b54ce5011f1442bc828dbe74d90123c976222452efce3fc0d70'
AND (
token = 'Hs08lmUdhEAof9Eohb5S4wZNAR6BVToiTg2a6aH2oCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)