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