UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/tzU+agl+H6zb65FOBvuvGVhfQK0u/VRLX9V+7v/yLA=' 
WHERE 
  key_id = '267a13c833a230641fbdbd4305c93a4ecdae7b2aac024b0f8d2d82bee5999144' 
  AND (
    token = '/tzU+agl+H6zb65FOBvuvGVhfQK0u/VRLX9V+7v/yLA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044