UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sX7vB7fha0cVpsUb1E6xAVt1aW0910p4I400rskXpgc='
WHERE
key_id = '0c0a1de3b7a1e7fa6dd72fecf0ddcc8a9b7a24ae25e2adfcc5d4da5cc6c51553'
AND (
token = 'sX7vB7fha0cVpsUb1E6xAVt1aW0910p4I400rskXpgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)