UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MJzTxALSJ3kFQSr2nszV9QVa2Dy3nmDPzG1xCwIe0fY='
WHERE
key_id = '50179eb46531ddf86762e9b0c1df07a102246b587e41010e6327634c0ef1ccbb'
AND (
token = 'MJzTxALSJ3kFQSr2nszV9QVa2Dy3nmDPzG1xCwIe0fY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)