UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WZWOywyAy3gSup0zjozxdSvhBy66ifeB1nD4hYo/jVs='
WHERE
key_id = 'd6b57cbf0571762436a2ca7c4c8b403c0c597c1417e3b52a063560b06eb66e1a'
AND (
token = 'WZWOywyAy3gSup0zjozxdSvhBy66ifeB1nD4hYo/jVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)