UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6icTA7oCZm8NHC8a/DLcCxGAZ6UtOYKbY4PH0xnmycA='
WHERE
key_id = '23db1c7e657c97a71113027cb50853df191e3abd22f2cc90a52debeeeb8c947a'
AND (
token = '6icTA7oCZm8NHC8a/DLcCxGAZ6UtOYKbY4PH0xnmycA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)