UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RC2SnnEDMLTKNNK3ionypKcn7zz9ICSXKlZmgZItwYI='
WHERE
key_id = 'd395a91532afa34443b76aaffbb8df7427d3de6bc516c48ee065a25a3bbfaf8b'
AND (
token = 'RC2SnnEDMLTKNNK3ionypKcn7zz9ICSXKlZmgZItwYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)