UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tp8dgelU12Px/uClXCT9hGsGK6fPPagzQ1Qmwfl2ZW8='
WHERE
key_id = '942f9dad8e5c41e1186b04b07e32d4ec818dfd276bad68d8cb9e17313c35f5a8'
AND (
token = 'tp8dgelU12Px/uClXCT9hGsGK6fPPagzQ1Qmwfl2ZW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)