UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxuRBeGDWl4KBHeQDRI7HHXoRkU1ovOg0o6L9UJpmHs='
WHERE
key_id = '6059e3c09746d12c38baffff6ff4bf20c24afef57b57c36cc70257e2d9534802'
AND (
token = 'sxuRBeGDWl4KBHeQDRI7HHXoRkU1ovOg0o6L9UJpmHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)