UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9TigNsggqnB1kbF4ie5G2n/PiPVFqp5GVXQfovV1HCw='
WHERE
key_id = '192fb87f77a98262054e585618f562b88b00666bbd5fc2df7883bcc05662c6aa'
AND (
token = '9TigNsggqnB1kbF4ie5G2n/PiPVFqp5GVXQfovV1HCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)