UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'm/zUyd/yiMlyPUydlaYkSKTUQjebhfj9I95RtXuSjbI=' 
WHERE 
  key_id = '946ee7155e418abc44420c36a34ba3c4d6d3d88fba092bc66d85e4b7d2a9b69f' 
  AND (
    token = 'm/zUyd/yiMlyPUydlaYkSKTUQjebhfj9I95RtXuSjbI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034