UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HxG15AxBn7nihxTqegSb6EHKNIycVVUAKFIQdqAFrig='
WHERE
key_id = 'f84e09ad4987b82fb64af01e3f96917b27fb56886489547a0b041d822ff40f0e'
AND (
token = 'HxG15AxBn7nihxTqegSb6EHKNIycVVUAKFIQdqAFrig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)