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