UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yWuW2G2yLjN2U+d6pL9Kt2fOFIg/thHJ1FmKpfwmB+I=' 
WHERE 
  key_id = 'c01d9400eb84d35d43014f712e07b52bac4925bbd230317998e8c834df688571' 
  AND (
    token = 'yWuW2G2yLjN2U+d6pL9Kt2fOFIg/thHJ1FmKpfwmB+I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033