UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hHa+HDTyL9OwcKhEkHWGsYRR1Gthaikqy7V+uyIw5fM=' 
WHERE 
  key_id = '3ede0f268b3e051f3a07dd71edc5c8139333163d98f3bafb66225512948eecf0' 
  AND (
    token = 'hHa+HDTyL9OwcKhEkHWGsYRR1Gthaikqy7V+uyIw5fM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045