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