UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ceLMw2mGu/rW9rwEFfMTh8ns1AEcfQzsasHKGwgBdh4='
WHERE
key_id = 'bcce4cc612b1147e087d188cea9b08ca4ffd5017997e2ef60dc9bb63c0e9a615'
AND (
token = 'ceLMw2mGu/rW9rwEFfMTh8ns1AEcfQzsasHKGwgBdh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)