UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hT3LNMxYupyfEuq8GEL9CD/BtTdIcIA70AS3t8g5cQg='
WHERE
key_id = 'f9df647c0d7222f2df11fad4cd34a4b369a5c78c458de709fb831aeffd2fea8f'
AND (
token = 'hT3LNMxYupyfEuq8GEL9CD/BtTdIcIA70AS3t8g5cQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)