UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '96gk1WF88AFNVaiCxwghTZ4EzQWgQ9+/q3VPw59VMqI=' 
WHERE 
  key_id = 'fa1ecfbf89b6b30ba096a1724c0ee38ab1c705282923366f1e12ac5df3fc44d7' 
  AND (
    token = '96gk1WF88AFNVaiCxwghTZ4EzQWgQ9+/q3VPw59VMqI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023