UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2O12jL3jTzuYbJyJx2rV/z8e643lIF+0eDYyMfL07Zk='
WHERE
key_id = 'd7ed8218e857467fc0a4ebb8dbcb6ebb3fe9b7add1455c5a57099ea95a31abb9'
AND (
token = '2O12jL3jTzuYbJyJx2rV/z8e643lIF+0eDYyMfL07Zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)