UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QKN7Fh04eWUR6P3JClkZjlRVoLAn412jskUY0IntIzA='
WHERE
key_id = '4e0a42a289198c4e68dbfe0a1883ec6937cf4371d2a657f29558d47e10f8b8ef'
AND (
token = 'QKN7Fh04eWUR6P3JClkZjlRVoLAn412jskUY0IntIzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)