UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Cj9twVW/pPmoXSB8go8cGI4t5TU3bzTbbkw6NS6jqA='
WHERE
key_id = '0a199c514b5c5906d08d1d804d16195b74bdc58d5aa8b7658ae6257f98ea8f12'
AND (
token = '0Cj9twVW/pPmoXSB8go8cGI4t5TU3bzTbbkw6NS6jqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)