UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O78sPjQAMbsv3kdvnvjxlM2uC4C2b9ePUm9poT7yCf8='
WHERE
key_id = '5816c059b31bfa1907be2e2a2b186f58b4684f209dcb66fcc3ef38b105ac053e'
AND (
token = 'O78sPjQAMbsv3kdvnvjxlM2uC4C2b9ePUm9poT7yCf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)