UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'izml4hFSCJ6uBWYI/rWAO42XO3Y2fjENmnu9ANQ4KPY=' 
WHERE 
  key_id = 'ae9c00497e0f9186ce9e989ee3638eb6b35b319e9f028f91308fcf37480b480b' 
  AND (
    token = 'izml4hFSCJ6uBWYI/rWAO42XO3Y2fjENmnu9ANQ4KPY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046