UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9q9afIAqhf38jX9jqGr7YhNliAaopLO7aEwOJn//Fgw='
WHERE
key_id = 'b7af3df1cc59a761b640da6d1cc340657512834014fa16648e3b00025a6255b9'
AND (
token = '9q9afIAqhf38jX9jqGr7YhNliAaopLO7aEwOJn//Fgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)