UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kMHkHHWsYfvUa09c9dldiBXwVZ0MOkUryYmSZzh8WZY='
WHERE
key_id = '7d4f20b71c3aa7508361522cc766ed4f17e736b1ffb15c6bd8e8daa897134a46'
AND (
token = 'kMHkHHWsYfvUa09c9dldiBXwVZ0MOkUryYmSZzh8WZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)