UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oZWOIx3p8RyQrhFiRhoICSaY0e9VHpSQnLo8pYnA1s='
WHERE
key_id = '8bab25b9122817bddccd012e60f67464fefb9d3f79f5f2b6d994cbec945c21f6'
AND (
token = '8oZWOIx3p8RyQrhFiRhoICSaY0e9VHpSQnLo8pYnA1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)